Previous Topic

Next Topic

Query Examples

The following examples show some of the ways in which you can use the Intelligent Query Architect to extract a subset of data.

Note: There are many ways to create SQL statements. The SQL statements listed in these examples are provided for personal instruction only.

In This Section

Example: Find recipients for e-mail

Example: Find current registrants

Example: Find registered members by city

Example: Find members by company and state

Example: Find purchases by amount and date

Example: Find members by state or join date

Example: Find total number of pledges by amount

See Also

Intelligent Query Architect (IQA)

Understanding Intelligent Query Architect

Query Definition

Adding a Filter

Specifying Output Columns

Specifying Sort Order

Integration with iMIS modules


ASI logo 10.6 Production Release. Updated 7/27/2006 3:53:14 PM
© 2009 by Advanced Solutions International, Inc. All rights reserved.